IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[cms_sp_DashboardSelectAll]') AND type in (N'P', N'PC'))
	DROP PROCEDURE [dbo].[cms_sp_DashboardSelectAll]
GO
create procedure [dbo].[cms_sp_DashboardSelectAll]
as
select 
	[DashboardId] as Id,
    [DashboardName],
    [Description],
    [LoadUrl],
    [AdminUrl],
	[DashboardWidth] as Width,
    [CreatedBy],
    [DateCreated],
    [LastUpdatedBy],
    [DateLastUpdated]
from [dbo].[Dashboards]


GO

